Under this point, this paper studies and implements the multidimensional query analysis system 根據(jù)以上分析,本文研究并實(shí)現(xiàn)了一個(gè)多維查詢分析系統(tǒng)。
The multidimensional data model of the sample database is designed as star schema . the etl tool is implemented curtly and the tool is independence on structure in order to make the multidimensional query analysis be independent of data source, thereby, the expansibility of system is enhanced 以星型模式設(shè)計(jì)了實(shí)例數(shù)據(jù)庫的多維數(shù)據(jù)模型,并簡單地實(shí)現(xiàn)了數(shù)據(jù)的提取與轉(zhuǎn)換工具,該工具獨(dú)立于查詢分析系統(tǒng),使得查詢分析與數(shù)據(jù)來源無關(guān),增強(qiáng)了系統(tǒng)的可擴(kuò)展性。
The techniques of establishment and access for multidimensional dataset are discussed . we implement multidimensional query, including drill up / down, slicing etc, and the update of multidimensional data set by the technique of mdx, ado md and dso . the expression of operation by graphic is also implemented 對多維數(shù)據(jù)集的生成和訪問技術(shù)作了討論,通過mdx、adomd和dso技術(shù)實(shí)現(xiàn)了olap多維查詢和多維數(shù)據(jù)集的更新,其中包括淺化、深化、切片等操作,并進(jìn)一步實(shí)現(xiàn)了操作的圖形化顯示。